class AddMainPropertiesToCustomers < ActiveRecord::Migration
  def self.up
    add_column :customers, :issue_by,:string
    add_column :customers, :issue_province,:integer
    add_column :customers, :issue_date,:date
    add_column :customers, :issue_expire,:date

    add_column :customers, :register_address,:string
    add_column :customers, :register_tel_no,:string
    add_column :customers, :register_home_live,:date
    add_column :customers, :register_home_position,:string
    add_column :customers, :register_home_characteristic,:string
    add_column :customers, :register_home_near,:string

    add_column :customers, :present_address,:string
    add_column :customers, :present_tel_no,:string
    add_column :customers, :present_home_live,:date
    add_column :customers, :present_home_position,:string
    add_column :customers, :present_home_characteristic,:string
    add_column :customers, :present_home_near,:string

    add_column :customers, :occupation_id,:integer
    add_column :customers, :work_position,:string
    add_column :customers, :work_name,:string
    add_column :customers, :work_address,:string
    add_column :customers, :work_tel_no,:string
    add_column :customers, :work_start,:date
    add_column :customers, :work_salary,:decimal
    add_column :customers, :other_income,:decimal

    add_column :customers, :married_name ,:string
    add_column :customers, :married_occupation_id,:integer
    add_column :customers, :married_work_position,:string
    add_column :customers, :married_work_name,:string
    add_column :customers, :married_work_address,:string
    add_column :customers, :married_work_tel_no,:string
    add_column :customers, :married_work_start,:date
    add_column :customers, :married_work_salary,:decimal
    add_column :customers, :married_other_income,:decimal

    add_column :customers, :black_list,:boolean
    add_column :customers, :rate,:integer
    add_column :customers, :contact_address,:string
    
  end

  def self.down
    
  end
end
